package com.icity.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import com.icity.entity.ChannelActive;
import com.icity.entity.ChannelAddUser;
import com.icity.entity.ChannelStart;
import com.icity.entity.ChannelTotal;
@Mapper
public interface ChannelMapper {

    @Select("select * from tbl_statistics_channel_total")
	List<ChannelTotal> getChannelTotal();

    @Select("select count(id) from tbl_statistics_channel_total")
	int getChannelTotalCount();

    @Select("select * from tbl_statistics_channel_adduser where now_date between #{startDate} and "
    		+ "#{endDate}  order by now_date")
	List<ChannelAddUser> getChannelAddUser(Map<Object,Object> map);
    @Select("select * from tbl_statistics_channel_active where now_date between #{startDate} and "
    		+ "#{endDate}  order by now_date")
	List<ChannelActive> getChannelActive(Map<Object, Object> map);
    @Select("select * from tbl_statistics_channel_start where now_date between #{startDate} and "
    		+ "#{endDate}  order by now_date")
	List<ChannelStart> getChannelStart(Map<Object, Object> map);

}
